﻿<?php 
include 'top1.php';
include '../connect.php';
?>

<div class="ny-right">

  <h3>成绩查询</h3>

     <div id="twjs">
<br><br>

<table border="1">

<tr><td>学号</td><td>姓名</td> <td>课程名</td> <td>授课教师</td> <td>学分</td>   <td>学期</td><td>修改</td> <td>删除</td></tr>

   <?php
  $key=$_POST['search'];
    
	
	
			$query1 = mysql_query("select * from mark where uname like '%$key%'");
			
					 while($row = mysql_fetch_array($query1,MYSQL_ASSOC)){
			
						echo '
						<tr><td>'.$row['num'].'</td><td>'.$row['uname'].'</td> <td>'.$row['course'].'</td> <td>'.$row['teacher'].'</td> <td>'.$row['mark'].'</td>   <td>'.$row['term'].'</td><td> <a href="mark_xiu.php?id='.$row['id'].'">修改</a></td>  <td><a href="?action=del&id='.$row['id'].'">删除</a></td></tr>
						
						';
				}
				
			?>

</table>

 <style  type="text/css">
 table td { padding:10px; }
  table td p { width:400px;word-break:break-all ;}
 
 </style>

</div>
</div>

<div class="clear"></div>
</div>


<?php 
include 'foot.php';

?>
